1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 namespace SoftQuanLyNhaHang.Views
12 {
13 public delegate void LinkSuaBom_EventHandler(object sender, EventArgs e, int IdBom, string _KieuSua_ThemMoi);
14
15 public delegate void Link_QuayLai_BomChiTiet_EventHandler(object sender, EventArgs e);
16
17 public partial class uctBom_ChiTiet : UserControl
18 {
19
20 public uctBom_ChiTiet()
21 {
22 InitializeComponent();
23 }
24
25 public static uctBom_ChiTiet uctBomCt = new uctBom_ChiTiet();
26
27 public event LinkSuaBom_EventHandler Link_SuaBom;
28
29 public event Link_QuayLai_BomChiTiet_EventHandler Link_QuayLai_BomCt;
30
31 int _getIdBomItem = 0;
32 int _IdKho =0;
33 string _TrangThai = "SuDung";
34 double _GiaBanSp = 0;
35 float _SoLuongSp = 0;
36 string _TenSanPham = string.Empty;
37 int _DonViTinhId = 0;
38 string _TenDonViTinh = string.Empty;
39 private int _getIdBom = 0;
40
41 public void HienThiChiTietBom(int IdBom)
42 {
43 _getIdBom = IdBom;
44
45 this.HienThiBom(_getIdBom);
46 this.HienThiDanhSachMuaHang(_getIdBom);
47 //this.HienThiDanhSachKhuyenMai(_getIdBom);
48 }
49
50 private void HienThiBom(int _getIdBom)
51 {
52 DataTable dtBom = new DataTable();
53 dtBom = Controllers.BomCtrl.FillDataSet_getBom_ByIdBom(_getIdBom).Tables[0];
54
55 if (dtBom.Rows.Count > 0)
56 {
57 foreach (DataRow item in dtBom.Rows)
58 {
59 txtTieuDe.Text = item["TieuDe"].ToString();
60 txtSoLuongGoi.Text = item["SoLuong"].ToString();
61 txtMoTa.Text = item["MoTa"].ToString();
62
63 txtNgayBatDau.Text = CauHinhHeThong.Format_HienThiNgayThangNam(item["NgayBatDau"].ToString(),false);
64 txtNgayKetThuc.Text = CauHinhHeThong.Format_HienThiNgayThangNam(item["NgayKetThuc"].ToString(), false);
65 }
66 }
67 }
68
69 private void HienThiDanhSachMuaHang(int _getIdBom)
70 {
71 dgvDsMuaHang.Rows.Clear();
72 //Ẩn cột đầu tiên
73 dgvDsMuaHang.RowHeadersVisible = false;
74 //-https://stackoverflow.com/questions/17404969/right-align-a-column-in-datagridview-doesnt-work
75 this.dgvDsMuaHang.Columns["STTMuaHang"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
76 this.dgvDsMuaHang.Columns["STTMuaHang"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
77 //this.dgvDanhSachNhapHang.Columns["STT"].SortMode = DataGridViewColumnSortMode.NotSortable;
78
79 this.dgvDsMuaHang.Columns["TenDonViTinhMuaHang"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
80 this.dgvDsMuaHang.Columns["TenDonViTinhMuaHang"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
81
82 this.dgvDsMuaHang.Columns["SoLuongMuaHang"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
83 this.dgvDsMuaHang.Columns["SoLuongMuaHang"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
84
85 this.dgvDsMuaHang.Columns["GiaVonMuaHang"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
86 this.dgvDsMuaHang.Columns["GiaVonMuaHang"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
87
88 this.dgvDsMuaHang.Columns["GiaBanMuaHang"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
89 this.dgvDsMuaHang.Columns["GiaBanMuaHang"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
90
91 this.dgvDsMuaHang.Columns["TrangThai"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
92 this.dgvDsMuaHang.Columns["TrangThai"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
93
94
95
96 DataTable dtBomItem = new DataTable();
97
98 //select từ bảng bán hàng
99 dtBomItem = Controllers.BomItemCtrl.FillDataSet_getBomItem_SearchAll(_getIdBomItem, _getIdBom, _IdKho, "", _TrangThai, "", _GiaBanSp, _SoLuongSp, _TenSanPham, _DonViTinhId, _TenDonViTinh).Tables[0];
100 int _stt = 0;
101 double soluong = 0;
102 double giaban = 0;
103 double giavon = 0;
104
105 if (dtBomItem.Rows.Count > 0)
106 {
107 string LoaiHh = "";
108 foreach (DataRow item in dtBomItem.Rows)
109 {
110 _stt += 1;
111 int n = dgvDsMuaHang.Rows.Add();
112
113 dgvDsMuaHang.Rows[n].Cells["IdBomItemMuaHang"].Value = item["IdBomItem"].ToString();
114 dgvDsMuaHang.Rows[n].Cells["STTMuaHang"].Value = _stt.ToString();
115 dgvDsMuaHang.Rows[n].Cells["ChuanMaVachMuaHang"].Value = item["ChuanMaVach"].ToString();
116 dgvDsMuaHang.Rows[n].Cells["TenSanPhamMuaHang"].Value = item["TenSanPham"].ToString();
117
118 dgvDsMuaHang.Rows[n].Cells["TenDonViTinhMuaHang"].Value = item["TenDonViTinh"].ToString();
119
120 soluong = CauHinhHeThong.Format_SoDeTinhToan(item["SoLuong"].ToString(),false);
121 dgvDsMuaHang.Rows[n].Cells["SoLuongMuaHang"].Value = CauHinhHeThong.Format_SoDeHienThi(soluong, false);
122
123 giavon = CauHinhHeThong.Format_SoDeTinhToan(item["GiaNhap"].ToString(),false);
124 dgvDsMuaHang.Rows[n].Cells["GiaVonMuaHang"].Value = CauHinhHeThong.Format_SoDeHienThi(giavon, true);
125
126 giaban = CauHinhHeThong.Format_SoDeTinhToan(item["GiaBan"].ToString(),false);
127 dgvDsMuaHang.Rows[n].Cells["GiaBanMuaHang"].Value = CauHinhHeThong.Format_SoDeHienThi(giaban, true);
128
129 LoaiHh = item["LoaiHangHoa"].ToString();
130 if (LoaiHh == "MuaHang")
131 {
132 dgvDsMuaHang.Rows[n].Cells["TrangThai"].Value = "Mua hàng";
133 }
134 else
135 {
136 dgvDsMuaHang.Rows[n].Cells["TrangThai"].Value = "Hàng khuyễn mãi";
137 }
138
139 }
140
141
142 }
143
144
145
146 }
147
148 /*
149
150 private void HienThiDanhSachKhuyenMai(int _getIdBom)
151 {
152 dgvDsKhuyenMai.Rows.Clear();
153 //Ẩn cột đầu tiên
154 dgvDsKhuyenMai.RowHeadersVisible = false;
155 //-https://stackoverflow.com/questions/17404969/right-align-a-column-in-datagridview-doesnt-work
156 this.dgvDsKhuyenMai.Columns["STTKm"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
157 this.dgvDsKhuyenMai.Columns["STTKm"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
158 //this.dgvDanhSachNhapHang.Columns["STT"].SortMode = DataGridViewColumnSortMode.NotSortable;
159
160 this.dgvDsKhuyenMai.Columns["TenDonViTinhKm"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
161 this.dgvDsKhuyenMai.Columns["TenDonViTinhKm"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
162
163 this.dgvDsKhuyenMai.Columns["SoLuongKm"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
164 this.dgvDsKhuyenMai.Columns["SoLuongKm"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
165
166 this.dgvDsKhuyenMai.Columns["GiaVonKm"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
167 this.dgvDsKhuyenMai.Columns["GiaVonKm"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
168
169 this.dgvDsKhuyenMai.Columns["GiaBanKm"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
170 this.dgvDsKhuyenMai.Columns["GiaBanKm"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
171
172
173 DataTable dtBomItem = new DataTable();
174
175 //select từ bảng bán hàng
176 dtBomItem = Controllers.BomItemCtrl.FillDataSet_getBomItem_SearchAll(_getIdBomItem, _getIdBom, _IdKho, "", _TrangThai, "HangKhuyenMai", _GiaBanSp, _SoLuongSp, _TenSanPham, _DonViTinhId, _TenDonViTinh).Tables[0];
177 int _stt = 0;
178 double soluong = 0;
179 double giaban = 0;
180 double giavon = 0;
181
182 if (dtBomItem.Rows.Count > 0)
183 {
184 foreach (DataRow item in dtBomItem.Rows)
185 {
186 _stt += 1;
187 int n = dgvDsKhuyenMai.Rows.Add();
188
189 dgvDsKhuyenMai.Rows[n].Cells["IdBomItemKm"].Value = item["IdBomItem"].ToString();
190 dgvDsKhuyenMai.Rows[n].Cells["STTKm"].Value = _stt.ToString();
191 dgvDsKhuyenMai.Rows[n].Cells["ChuanMaVachKm"].Value = item["ChuanMaVach"].ToString();
192 dgvDsKhuyenMai.Rows[n].Cells["TenSanPhamKm"].Value = item["TenSanPham"].ToString();
193
194 dgvDsKhuyenMai.Rows[n].Cells["TenDonViTinhKm"].Value = item["TenDonViTinh"].ToString();
195
196 soluong = CauHinhHeThong.Format_SoDeTinhToan(item["SoLuong"].ToString(), false);
197 dgvDsKhuyenMai.Rows[n].Cells["SoLuongKm"].Value = CauHinhHeThong.Format_SoDeHienThi(soluong, false);
198
199 giavon = CauHinhHeThong.Format_SoDeTinhToan(item["GiaNhap"].ToString(), false);
200
201 dgvDsKhuyenMai.Rows[n].Cells["GiaVonKm"].Value = CauHinhHeThong.Format_SoDeHienThi(giavon, true);
202
203 giaban = CauHinhHeThong.Format_SoDeTinhToan(item["GiaBan"].ToString(), false);
204 dgvDsKhuyenMai.Rows[n].Cells["GiaBanKm"].Value = CauHinhHeThong.Format_SoDeHienThi(giaban, true);
205
206 }
207
208 }
209 }
210 */
211
212 private void linkLabelThayDoi_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
213 {
214 if (this.Link_SuaBom != null)
215 {
216 this.Link_SuaBom(sender, e, _getIdBom, "Sua");
217 }
218 }
219
220 private void linkLabelQuayLai_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
221 {
222 if (this.Link_QuayLai_BomCt != null)
223 {
224 this.Link_QuayLai_BomCt(sender, e);
225 }
226 }
227
228 private void linkLabelXoa_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
229 {
230 DialogResult dr = MessageBox.Show("Bạn có chắc chắn xóa?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
231 if (dr == DialogResult.Yes)
232 {
233 Controllers.BomCtrl.DeleteBom(_getIdBom);
234
235 if (this.Link_QuayLai_BomCt != null)
236 {
237 this.Link_QuayLai_BomCt(sender, e);
238 }
239 }
240 else
241 {
242 return;
243 }
244
245 }
246
247 }
248 }